EPTNUM2TXT

(Only available in the full registered version of Edwin's Power Tools.)

Translates a number into English Language text.

Syntax

EPTNUM2TXT(number, frac, places, dollar_txt, cent_txt, output_case, smart_case)

number is the number to be translated into English. It can be either a positive or a negative number; with/without decimal places. It may also be in scientific format, e.g. 234E+17

frac is a number either 1, 2, or 3. It determines the way decimal places (, if any,) are being treated. Default value is 1. (Optional)

Set frac equals to

If decimal places exist

1 or omitted

Translated into a fraction. e.g. 0.27 = 27/100 ; 0.12345 = 12345/100000

2

Translated into English words. e.g. 0.27 = zero point two seven

3

Completely ignore any decimal places. e.g. 1.6 = one

place determines how many decimal places (,if any,) to which you want to round number. (Optional)

dollar_txt is the text string to be placed before the decimal places. (Optional) For example, when translating the number 123,

dollar_txt

Translation output

Dollar

One-Hundred Twenty-Three Dollar

Pound

One-Hundred Twenty-Three Pound

cent_txt is the text string to be placed after the decimal places. (Optional)

For example, when translating the number 123.25,

dollar_txt

cent_txt

Translation ouput

Dollar

Cent

One-Hundred Twenty-Three Dollar Twenty-Five Cent

Pound

Pence

One-Hundred Twenty-Three Pound Twenty-Five Pence

output_case is a number either 1, 2 or 3. It determines whether the output text string is in upper, lower, or proper case. Default value is 1. (Optional)

Set output_case equals to

Effect

1 or omitted

Output text in UPPER case

2

Output text in lower case

3

Output text in Proper case

smart_case is a Boolean value either TRUE or FALSE. It determines whether the word AND should always be in lower case. Default value is FALSE. (Optional)

Set smart_case equals to

Effect

TRUE

The word and always in lower case

FALSE or omitted

The word and follows the value of the variable output_case.

Limitations

  1. Absolute value of the number input must be smaller than one thousand nonillion. (US English definition : 1033) (i.e. -1E+33<x<1E+33)
  2.              Under Excel 5 and 7, length of translation output must not exceed 255 characters, which is the maximum length a cell can accommodate. Under Excel 8 (Excel 97), length of translation output must not exceed 32,000 characters
  3.      The language translation adopts the US English convention.

Remarks

EPTNUM2TXT translation employs the following definitions :